home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 17 / Developer Source Volume 17 (I-MODE Publications, Inc.)(2000).iso / oracl / mar97 / koopf102.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  15.0 KB  |  630x197  |  4-bit (14 colors)
   ocr: FIGURE 2: Loading data in primary-key order forces good clustering. Note the difference in percent of clustering for rows. blkixchk.sq! Alloc. 8 Leat Avg. Leafe Blocks Avg, Data Blocks Distinct Number Pct. Cluster Index Uniqueness Blocks Level Blocks per Key per Kcy Keys of Rows Clustering for Rows Estimote Statistics: KOOPMI.TESI_PK UNIGUE 775 2 518 1 I 79,794 79,139 1,665 2.10 KOOPMLIESTLFLAUDLDT NONUNIGUE 660 2 646 9 143 68 79,139 52,577 66.90 Compule Statistics: KOUPMIIESTTPK UNIGUE 775 2 512 1 1 79,112 79,112 1,156 1.49 KOOPMILTESTLALAUDL.DI NONUNIQUE 660 2 640 9 773 68 79,112 52,630 66.5 ...